SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028960 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028960 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645300,810086,544015,1016188,740541,613117,992255,582903,879998,725072,852264,738301,790375,425799,892238,261234,691597,819793,379476,305882,527896,792939,65881,268189,1005937,172550,795393,549739,950603,382394,776606,781671,169970,184249,338980,263466,281680,498841,897574,169031,543420,841068,825725,46553,455777,381497,649355,144987,92315,540614,316531,581164,822911,354679,304185,531836,88790,627665,116837,312263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]