SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206180 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206180 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588599,181549,812174,126730,694665,308033,782205,34937,124625,48646,319842,782085,571833,268962,488084,411926,781442,317374,777624,244254,810860,213421,999489,641655,936502,343477,328935,53205,917969,1023276,916381,748118,577425,610067,279909,282916,526138,843448,140880,278336,680411,791239,695571,677997,112001,726860,697525,36559,401366,735735,521589,178729,576063,352487,938365,44166,964572,750563,163704,633595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001257s ]