SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429407 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429407 [ RunTime:0.005292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482286,404612,324806,284768,292198,850798,642734,105220,716971,901876,290959,293615,287515,452555,102665,192643,860429,505087,1045379,984878,217442,736193,523550,440787,494833,179553,495160,581016,779278,114371,233526,844144,513520,541474,185296,946849,345504,669200,989448,127086,860087,126103,926148,803976,776553,758291,103014,727897,396210,198101,719598,57621,525330,638267,349034,720534,764021,850935,246966,38929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]