SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010280 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010280 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211748,112499,1030845,553240,829561,250411,387847,823439,143678,63767,128180,1027962,612874,420870,925539,456980,814249,136057,508558,824422,594372,846711,992119,475569,787033,255521,600711,221043,532053,589124,841176,262378,795104,51273,252044,173938,213160,705114,927735,431767,830338,60552,825706,381073,1004862,719910,791414,107968,596300,629501,127484,440591,212163,202298,472740,63982,570595,700047,442227,524876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002383s ]