SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027031 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027031 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110172,267252,264002,342571,901063,807232,158905,346689,9785,635722,218061,349147,1012603,422965,640234,267082,644075,188508,830379,965896,578959,509257,1046668,608254,875059,849141,867698,355878,253245,760369,380747,323978,399979,659489,53546,694961,811793,920441,906334,541155,879439,531347,431492,940766,424605,604003,644527,605854,287286,543493,538574,73378,846553,568476,422467,54848,474950,893780,297534,758786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]