SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104809 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104809 [ RunTime:0.003161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994339,35961,1001399,765627,61916,381380,156527,74388,959577,737667,1038615,109085,785088,798651,1002635,654476,118113,350073,184000,314599,486748,915504,754636,107548,461032,915096,738385,805849,696380,1006161,138656,784066,956756,853003,15675,65865,866226,221928,17878,586728,538915,432446,622651,491879,543698,778098,94156,863473,738376,671189,843301,599702,623130,499791,1003155,942761,175390,322990,827849,996237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]