SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546620 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546620 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320245,425927,369414,620082,1011646,642893,87605,557478,856156,818369,145121,425620,436252,673438,8474,49515,776055,324385,339030,153066,462165,817261,283050,509728,745143,136664,902196,946443,559824,955694,772714,6972,70746,241450,65757,880755,168395,835299,298781,755574,523156,246548,999990,176978,250242,955860,999416,278544,1045776,814047,358268,879140,734328,401303,48813,264080,1039227,880028,374940,427367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]