SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261198 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261198 [ RunTime:0.002665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512104,562785,798577,291685,400439,329169,761610,639361,880905,460034,1025164,513090,658029,973002,149326,361712,736085,446183,306584,287569,646069,525423,941762,503121,260620,16981,247325,894475,529669,775935,547858,621543,23299,521173,99371,971509,421143,934802,687007,538651,712057,382139,679821,1044689,778997,284645,899618,845598,124067,142854,977015,354112,612216,380630,958255,514505,48890,692015,324724,679825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]