SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101803 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101803 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653071,351880,722945,656540,408060,300749,590715,754183,10632,620965,433933,542057,212059,44174,941588,653352,749892,898537,693053,256524,392122,278454,855305,229434,980979,635136,911710,913352,955067,484285,871924,564910,820637,82816,689989,447529,935893,500981,617835,875646,503590,607720,967272,301936,355151,1017201,309621,776008,1027587,120370,205472,57321,516572,716402,150716,395762,464795,466820,524509,1045817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]