SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191301 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191301 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604204,510300,1037463,481455,924220,982254,836110,987026,662339,710313,597897,739065,266883,660822,281478,793404,54411,244418,680409,118559,632883,973348,312742,390232,278714,530522,698307,870059,85594,561696,344065,190305,1002476,35285,565433,443884,150242,428588,910310,12047,146160,884453,950094,600912,276811,978159,773431,673863,328462,382298,920413,151371,456950,1003988,589203,81141,224766,422757,502567,487876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]