SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001842s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303438 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303438 [ RunTime:0.001281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319895,675291,607402,943801,378366,794067,621258,645459,1034065,174859,332329,466715,886371,853282,1047002,115620,602184,992112,456049,102009,951945,1011469,261795,897990,692019,549497,170701,305788,598595,671347,766544,837091,302988,753129,133468,177086,1024326,728650,179891,942953,914696,677671,142952,602988,641684,855695,759906,171062,86140,840759,176397,924268,233575,739552,579273,874069,41093,969425,925054,199042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]