SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012602 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012602 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5185,864758,751727,850327,162040,713996,976149,427832,463050,995063,146632,922871,1008604,91070,971199,541296,222575,150913,14919,643179,777141,695819,63819,457427,392717,841227,308127,337193,248577,362050,78273,345600,562624,760389,624655,1017454,1024348,757378,573919,427389,313568,511690,91255,846518,44017,281668,984595,528289,342390,805690,595269,330395,502400,124069,565741,325288,142857,305773,1042186,194165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]