SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503499 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503499 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037169,651281,972018,62197,141036,797211,18379,1039643,219639,428028,630701,701734,57346,11227,425521,816498,824724,964271,528663,976787,557248,385863,692072,575969,517374,822357,419722,739153,550272,1044641,473042,633844,647087,946590,538027,225233,353598,18720,735871,950467,141215,842944,338113,11583,999331,995183,565111,434102,540172,327002,590511,124548,210984,63889,461154,890781,628328,67443,729792,450517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]