SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319454 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319454 [ RunTime:0.002228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661022,723961,379492,393769,123672,894667,501271,247721,345932,771815,327195,1014917,565855,845619,16311,676090,1004542,965292,894660,92542,889328,24634,618129,835435,821503,706887,175031,779843,471687,973127,1003849,1032925,145906,174674,52032,284274,750160,147125,850020,424336,363453,902023,64674,736787,908429,691650,612143,956881,88711,621667,355606,963471,1036889,280841,782903,804294,1017805,343043,360336,396441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]