SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26961 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26961 [ RunTime:0.002805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190541,52935,887545,37988,707771,503380,571638,546172,688181,902559,814376,678169,116578,702531,254412,772247,945186,664945,987904,980382,369066,522299,300737,630344,915850,184404,500070,633972,902348,63586,939739,769626,671767,925974,770384,89503,131590,920222,840474,306172,320170,508329,602732,564021,856597,51297,154997,537059,581665,75649,531973,111404,913447,271989,444959,640905,89703,927988,764434,393702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002932s ]