SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387847 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387847 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406192,15290,201686,905416,230239,355539,6712,326720,125749,798149,742021,495507,422432,66899,816153,660272,557480,1018228,656170,192835,194016,577784,746533,869261,339942,590623,836537,79596,839988,289188,329445,257482,421003,911482,232104,302231,753457,809440,434237,673188,385871,804084,149777,400564,417533,551112,599826,170281,944528,440151,94781,106189,890744,426377,440634,43537,471017,790204,236098,47141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001834s ]