SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554694 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554694 [ RunTime:0.003420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571720,428432,704608,973984,433490,805363,323267,114991,388233,914654,988789,762757,195081,808595,518284,476570,523197,263906,467592,253548,43618,731100,396037,444263,475799,454128,962179,102236,771661,76388,358063,524131,571032,438824,776584,583778,124699,620956,226996,812347,440309,908422,69741,928513,656803,447769,272490,360525,828863,854372,159352,349428,388793,990545,498856,353445,177943,218369,383069,855444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000980s ]