SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 743811 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 743811 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912398,230187,1020033,464339,418230,824174,538668,111932,352640,377427,972158,425608,81405,856825,434482,240889,614668,280420,658822,481062,405092,931864,563589,384788,402831,125574,626274,39836,88939,932539,998924,708462,310799,75866,514408,876106,49555,484732,403438,221227,118182,63926,401558,465795,866463,559160,224988,234192,620899,862682,847316,875280,527715,901362,197050,962356,651590,568657,805380,338387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 743811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 743811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]