SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406751 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406751 [ RunTime:0.005669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125344,786757,689339,349297,668829,809887,644621,992683,1046333,91690,307165,455264,723669,413055,986477,161273,121070,993885,558531,675323,166967,467259,920078,586845,314722,842311,60513,1022678,759281,2671,872360,668685,531439,1025093,731032,858266,351809,543869,664800,1006013,1020375,371544,288305,805119,568588,963021,558519,883478,591529,608798,358872,829872,395173,110557,349350,490181,777524,974351,255025,610074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000711s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001134s ]