SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568474 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568474 [ RunTime:0.002526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368243,989222,48217,508917,443541,796726,37153,920784,532554,828893,229729,807528,1006814,603575,326920,697969,35893,266842,418127,1022106,661155,694017,634556,389652,1017685,562780,416869,206729,1012095,434553,974686,242570,610321,425814,660211,62070,661699,817470,757728,140898,894573,818799,315499,180289,71362,444391,308410,753223,170069,419799,1044726,490226,66656,784223,821388,204692,659717,956762,954242,448587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]