SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597984 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597984 [ RunTime:0.001451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909498,584897,694717,611011,776750,796281,153904,13420,658968,667503,268747,650600,711318,346492,207124,161656,80871,99312,503119,44694,236132,772551,107288,242026,916116,968031,984242,733016,552368,662961,100824,386590,1011553,696307,585319,116470,11731,608057,602056,922804,833282,233196,681207,440269,128039,1016208,701786,539877,438717,833247,508397,496128,804975,287676,930055,487663,547090,290459,500937,129675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]