SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49986 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49986 [ RunTime:0.002521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540954,135296,218936,820703,135117,76243,141584,61618,540122,624657,950632,1007034,346377,689667,112412,814386,554900,365318,41672,964965,1018088,659608,966286,377342,741773,542090,634270,708004,477927,310788,329830,255345,50228,203157,167011,280912,202774,915398,876326,809704,1037458,704884,882605,86142,197352,908924,344422,283175,4702,740658,222345,98026,524055,843222,717507,313252,722179,796194,592560,375670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]