SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431258 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431258 [ RunTime:0.003808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329217,893763,478256,100476,298964,866453,130811,358440,823311,424988,614446,89753,531519,115172,218534,683964,716868,363212,178033,110444,1038430,486495,322907,785537,109534,1046178,136782,137966,258552,494219,925873,168099,779308,62539,720439,759748,787502,482121,311754,447134,629785,501969,783588,912738,500599,601208,386869,881236,758293,860382,69769,147711,716125,4698,995082,977433,161097,525423,350930,1037198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]