SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544420 LIMIT 1 [ RunTime:0.002096s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544420 [ RunTime:0.003630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475201,145130,771404,708760,234743,754559,229843,934094,635579,93914,247308,136470,196126,194794,919817,225689,183350,279998,674372,88113,144086,430722,80939,161961,721818,543482,314858,682991,585303,1016635,727710,195871,678342,106514,576250,949923,712774,849890,796892,425722,72401,871200,109430,941524,250975,524972,155063,950080,694091,893725,417837,783405,528781,592223,85003,243066,597232,244159,703448,920686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]