SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338091 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338091 [ RunTime:0.002377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96920,715042,751498,618566,838416,910948,654770,480971,663168,954338,443906,796282,1010387,824578,1017690,547692,846395,495284,517791,546604,993396,296536,165659,736864,992860,1011071,752259,98264,51994,331372,285758,1045564,105189,184778,312181,981156,721392,807045,250790,584225,666422,118879,533809,914518,176386,310460,329168,925805,701520,978460,585472,856465,710032,637615,986377,694663,1019582,87547,760358,417285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]