SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438810 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438810 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582426,945917,250880,444986,185888,619151,928847,446521,293116,562338,871310,193372,272349,778678,154915,171332,437130,309503,262424,936026,903328,24333,611484,917980,781015,777704,439324,714610,422367,130113,512164,813718,83744,83434,750035,589268,869355,402222,279782,953117,158159,736396,725129,680437,55871,666807,374713,940942,154158,828749,402078,838699,38083,1013165,734058,703161,1000232,701414,408606,534308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]