SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40100 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40100 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136611,414526,99701,674331,732793,88447,998332,206298,212711,758890,191389,1003425,289350,924034,652068,283681,950587,87344,321769,169708,124356,255002,194254,369846,314013,350324,999898,172064,908765,539786,690804,113600,554677,203630,903348,895782,247710,796503,1089,1028801,543599,486605,1006499,57797,275809,86670,69123,567792,309739,684132,181723,910637,981467,418823,373590,267376,979748,911343,565371,926501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]