SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033499 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033499 [ RunTime:0.001360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147081,142405,880766,362387,627413,239383,57125,102310,133987,633374,33314,746894,64589,145781,570581,853348,650945,865595,992209,778033,939707,139417,575164,487588,324012,768164,801605,891119,417678,233697,638291,919127,934123,849570,804638,86740,1012434,816904,355135,830224,550313,1012245,360493,962747,697608,189837,868331,324653,829157,333496,162011,805884,424670,752412,394987,1021106,88936,513133,583441,679341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]