SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804101 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804101 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676867,511293,866520,811501,312240,228616,234082,943844,376311,420904,944504,699308,129470,436827,54906,391995,237905,241567,397302,980120,306164,17432,1018584,872705,423055,553830,828397,596467,654245,13593,859927,651870,479432,503007,338475,1035234,96034,133543,981655,48005,99661,461237,782248,540573,575417,164618,718513,671626,278480,304838,774142,523367,760165,614255,561291,521595,943103,170854,352746,255589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]