SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820400 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820400 [ RunTime:0.002675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895046,170818,46207,848433,878816,61991,274010,996611,464621,436099,582604,446623,647683,441050,254008,102487,857514,440352,625388,441988,241240,19945,979683,17476,592301,353480,649718,667296,266132,454895,598902,245510,64895,476565,814274,971562,540255,529062,872735,438075,524388,407837,308183,725854,349763,743166,691721,890775,136554,247385,580279,727931,32719,287727,77491,174632,688918,535924,316169,368248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]