SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324809 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324809 [ RunTime:0.002227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209640,371524,574681,778028,900062,448298,670996,373995,771629,679488,778385,1024193,609802,112153,497465,261730,981739,487640,759746,334079,1045629,530942,959074,951009,973657,872653,498223,236627,897766,799522,657316,158574,882302,682009,322826,795731,260001,1020855,440007,356441,536620,350567,108492,854389,389575,363670,590066,107841,483472,982305,258753,333634,827622,108885,403486,443593,840851,577199,682891,515571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]