SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001875s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425800 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425800 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639282,901457,334172,740738,835094,478769,220851,888524,358735,536868,512557,457972,429184,489751,1011401,755216,896751,1044923,18458,35467,72296,436337,919018,536433,482961,382232,346571,864162,15266,642271,105862,223621,176805,805539,809322,137618,565069,895545,235500,155799,373054,555157,272542,775258,1034391,833234,787220,51958,699065,366469,293570,839816,946357,481008,330561,463234,796559,952872,981066,156392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000939s ]