SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310491 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310491 [ RunTime:0.001354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004668,27526,474387,578617,414347,647201,670717,591106,257801,113984,745013,365445,823237,849105,658601,492646,934874,182739,981994,111828,860451,882622,404666,545207,516681,330214,496903,955105,718677,287445,1029114,736759,615628,464042,648748,289325,415216,7213,34160,880188,214340,758502,37874,385157,275071,453401,104256,171867,215644,1024638,1035222,376745,128839,928873,300657,925996,878621,596463,273768,866180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]