SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474582 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474582 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12130,965023,656122,89622,440090,1035626,460282,200036,19755,518897,579469,1047851,385803,921837,584869,961442,639430,27899,29627,15147,355859,910886,403624,856700,1034750,386122,492405,265799,298676,658491,612770,225942,397610,116842,432972,336889,76679,649972,512315,857369,582362,785365,299408,254356,860446,440323,482173,885184,355259,982780,271362,180278,917200,403058,842796,911792,926917,139775,743441,531519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000794s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]