SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031040 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031040 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797505,473603,21498,361986,539349,132413,563492,3580,465831,14696,279931,288184,940232,574141,273048,195910,308997,429128,1033854,312790,173729,1591,667854,654001,419539,563685,925598,804959,3962,379978,659218,3624,858284,962894,315717,1039815,45862,661985,609627,122511,278586,883740,226869,820506,672454,385579,180942,434044,989722,876482,840725,42145,601708,325494,208375,626685,331306,69591,710411,946050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]