SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 815396 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 815396 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470977,371905,172887,197164,675601,663411,493273,792197,31621,454393,1026413,498124,423608,523968,896017,887248,357872,182122,829060,686363,1000257,397548,756658,857204,881267,222983,685213,607444,486657,572325,130134,941340,274340,737418,592095,123143,732570,258279,726032,97182,965467,200397,776597,180007,300780,207670,816899,917018,402281,236250,855298,140024,540139,289310,63695,925826,363723,630162,1012634,379853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 815396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 815396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]