SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102615 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102615 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838665,883867,65285,4406,864579,700202,305764,119892,890287,132138,333802,502084,654452,98497,79436,285212,920107,476629,290662,345103,424674,51210,295389,700166,8565,538610,184119,883191,237074,830046,275835,684439,247733,961369,1003690,266293,561628,595477,470204,42781,446222,411725,933420,647480,512014,3443,479402,219508,82926,869723,940123,838982,947030,330782,551920,732255,1048614,7447,878055,672547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]