SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471968 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471968 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2189,309965,238071,140563,423197,777382,805753,93851,178177,472494,219487,740290,647860,983661,78419,931940,558685,931088,797256,279169,502096,604980,316178,887609,564545,563377,870898,620014,64499,329574,274419,573169,860867,743499,148201,105673,21710,363921,127894,1045284,146478,234390,189232,459116,57566,610867,312674,42952,597552,643112,667376,365036,470381,187993,425039,740452,1023196,437038,27455,400508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003134s ]