SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 906410 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 906410 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014818,425569,585820,64704,366598,963547,671440,612885,95193,571724,411027,445822,1039972,398145,587319,242483,154043,791062,194565,113450,1011140,416932,380243,1047188,510997,641459,783837,346622,768900,675262,1047989,823382,571837,351788,894622,898387,251576,467408,239261,129521,36065,816213,466121,822180,632889,836510,925447,810638,803160,674064,359966,41721,429592,85285,973194,949838,312359,558558,1046984,343092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 906410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 906410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]