SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036809 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036809 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152558,561960,574579,651371,182505,485541,408745,99658,665011,444828,434250,942903,733542,902218,58459,253600,365348,203736,876084,418322,863505,682905,13953,310801,383392,57519,131206,1028589,289709,287704,714841,627043,624979,457826,396865,1036658,595356,886779,658744,198515,866324,580668,766517,586073,353742,1020068,117375,800096,559940,993150,81036,939981,745242,788925,108349,322283,558674,1001671,330736,813537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]