SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047739 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047739 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329693,432738,924303,1034945,609932,93423,90138,364242,24923,282085,397814,638938,592150,178752,44233,804008,1028027,15515,977053,587940,379682,595698,590195,495059,260617,569310,991579,168149,524612,501830,1044768,324908,938330,1020741,396590,209510,657466,1013830,814859,377785,419509,103211,518835,455517,347792,497265,507905,182312,96359,844323,621383,71373,952845,353968,34353,971917,75105,866949,764804,874124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]