SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584800 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584800 [ RunTime:0.001429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020658,719987,192568,521493,1047258,140073,393804,621980,863108,1039405,248617,834838,1036913,1014318,705145,675052,573812,328439,236665,318943,937632,509967,474189,804835,894256,62832,839782,838506,540811,854178,456806,970050,368223,150271,27216,678966,110616,186387,128194,181419,654268,748753,622384,675370,480418,783154,143756,213357,641301,130010,967778,9855,243056,47674,814093,422530,972846,1007577,888152,191138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002811s ]