SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503813 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503813 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732759,911593,232900,884525,491397,170261,35539,858749,1039693,585752,972181,1031688,691668,284602,587095,260870,20339,351019,641474,863982,687909,173452,539844,783965,194835,1010072,662587,7820,617649,409571,716824,201608,1037417,780672,318219,820673,286873,403664,583611,18801,501318,958312,899407,298562,702026,89893,96858,531173,22918,163564,455804,843629,351840,824879,118970,630744,619866,689723,259471,1012411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]