SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97018 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97018 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843567,640188,441930,934729,291621,557232,425844,291881,101883,1012647,981530,677615,39598,986505,219654,596144,700102,875652,543435,231537,157679,447719,981425,140393,417710,939835,960898,1015120,586851,356138,908789,731475,239233,406678,364086,66724,364178,114445,628016,982781,781431,104093,160157,217155,981338,27074,831855,556293,126440,488862,7265,24226,474755,910235,291924,493518,63136,888192,655788,232372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]