SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381238 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381238 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (760928,653100,612622,887671,740928,185271,478144,937481,633238,850765,260168,375448,757474,892507,29688,394682,382110,597554,123666,645017,239162,33508,831584,183596,25514,588573,786395,334098,634855,771088,836718,997453,130618,747350,1006977,351561,527637,647897,33514,617325,757629,765449,656173,428193,515707,460123,8125,486467,481996,965157,671790,951168,268909,68875,972296,900103,152441,884339,510036,396984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]