SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017928 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017928 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356526,134092,173589,807420,620360,98202,204509,230871,107808,939077,428771,282806,668897,253299,149827,8371,650462,410125,465936,51670,942151,730545,468112,586042,822336,649418,817791,328031,201216,388722,713301,207040,1378,571339,944257,540319,796827,136591,507812,881333,456970,102850,801286,365019,426189,431672,406355,150962,445347,941898,969740,381190,167685,85586,493954,595902,280660,279548,852380,610447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]