SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 815240 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 815240 [ RunTime:0.003840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916800,239672,809463,910872,18682,677494,515735,545162,1045686,77677,932459,500805,162356,679038,541696,744857,449270,839540,896802,514029,602585,790084,201895,162127,639678,997548,475944,297044,3582,755207,562278,293161,851974,497745,260250,802895,654674,138618,703110,991157,554959,239552,357251,989079,230912,532187,233877,350487,519130,520552,1043002,112156,858870,490388,732502,625989,46494,825012,134765,135873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 815240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 815240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]