SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586308 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586308 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449408,15619,822318,930307,297839,854592,336841,799757,953629,677045,126089,1004642,19002,204594,114420,807799,394206,1001181,131191,615989,711946,471715,354857,485624,862566,994512,868690,480264,152181,887426,256991,207874,389617,158040,472342,312729,654465,764060,59154,957029,165341,546153,731966,545213,42297,849431,62964,24271,166868,200157,971628,395325,344307,637499,123481,156315,933054,1046748,478236,123190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]