SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282008 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282008 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808619,754470,1045606,388937,124022,223756,422054,413290,833271,988374,653105,426637,266121,529107,76581,803092,550763,88858,371033,26286,745318,200062,794949,361855,603679,992558,403382,941144,1018661,235051,970059,84368,194085,966859,230664,798116,1035592,928132,916885,693141,1037003,274856,702330,295269,466690,528756,366488,618000,509473,1026494,762742,2982,944010,717026,612667,737434,640914,417287,258883,49965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]