SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020097 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020097 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507411,689372,838190,1003636,902874,803009,429335,712084,941462,307095,141814,116471,286798,512384,478465,43260,658471,64727,1029326,877529,687570,1025420,46343,1022995,681491,243415,572627,313154,843623,492167,239807,196063,675990,416082,620597,204799,761870,923230,495022,93207,785011,110469,233092,833808,116933,51449,124196,45483,757603,600436,616692,7835,333819,404432,170195,889239,295436,494000,858875,123034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]