SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490985 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490985 [ RunTime:0.001477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126802,607845,894059,158665,333489,210075,704754,499878,550906,316221,60108,104407,423715,775872,422663,731142,917383,642766,276166,988977,409152,196526,835465,87286,410174,319805,609109,181273,426612,869759,94463,1045061,578160,433054,477606,767498,27937,730680,591944,391226,822933,489117,909974,338419,837630,121683,1036480,586592,804624,1046459,1005990,123314,834067,429817,497706,905087,111058,252396,317813,697211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]