SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007293 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007293 [ RunTime:0.002550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41826,610126,835373,1027912,984379,533832,338138,37292,157115,603038,431895,361728,482401,177772,147661,221805,1046054,835700,206613,876496,398660,105734,932948,309568,896200,775169,1016912,899741,1029908,458233,608152,715925,317433,1011502,959570,104904,987304,951969,919968,185943,796258,692950,288805,701463,827367,962789,392291,525034,636487,9925,308445,712222,457617,753336,40916,761928,2927,252772,709934,204030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]