SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368309 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368309 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78971,855557,989404,266168,1010046,582610,456651,484921,176818,638627,11611,1012860,461214,130060,190998,988957,943132,450805,959999,990514,63932,760765,245909,822048,829642,642246,740361,386609,380376,141023,298593,834343,796384,287132,723049,834421,219185,315989,1048355,389861,849904,988119,860468,914975,735874,278611,205374,115070,259717,251511,370704,792610,295413,884082,448358,964032,586,999935,1010884,871774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004256s ]