SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556623 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556623 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531623,191210,134264,263088,755716,370431,370150,1045931,962964,651576,610791,621072,971317,104576,67779,775617,12067,194685,811035,154464,174001,497670,656100,828214,721594,855557,500592,674019,708381,836106,837020,14184,287498,178191,45468,943549,542146,917704,240775,48682,614352,371832,962274,268210,1033589,800441,725114,393437,795209,212198,500515,436753,965107,1006100,905422,525937,882164,904446,723088,317733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]