SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403489 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403489 [ RunTime:0.002552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727956,40837,862368,813248,424108,747978,382450,280221,208828,538710,484075,479159,64018,389489,612514,384938,38550,785940,808585,773881,456577,631555,529464,328306,747111,139748,980771,76613,808533,820189,414407,582648,278892,83844,601522,48827,921583,281464,561018,525309,299143,726326,336826,222607,497684,174630,82093,114886,101996,498015,930509,749700,546690,467952,654651,558398,690418,494974,56126,383069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]