SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457936 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457936 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023241,875540,766888,42764,390546,337385,661222,485834,64050,155975,299810,374830,403007,103998,249233,214487,803698,250346,399584,747001,226247,632248,151171,863926,286189,596913,961121,132140,683493,471754,836848,609605,792617,297997,588645,612122,635361,493500,928030,681880,373365,791129,56014,719758,1019904,663324,228266,538001,419698,285682,818364,1038016,931610,224468,314761,676681,565553,808474,380435,519043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]