SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001854s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 917180 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 917180 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316983,398945,257178,249672,112367,744314,868174,803267,784884,465498,340593,352368,106528,194167,88566,866965,1005467,594219,114268,909451,158614,272581,610784,379653,137581,893258,753877,91100,752157,745187,477254,91462,184841,81595,424367,287555,59269,775914,628969,791125,1039845,666181,505772,213316,956038,491845,438040,1016558,151385,115239,157225,800016,854767,920905,397544,393096,766940,10001,297771,236021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 917180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 917180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]