SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268428 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268428 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26087,468121,562769,846634,104502,517560,985801,378884,294293,860424,500965,609471,182225,913865,1038698,116742,557589,373556,737476,479338,731281,695018,207537,549740,374170,877088,308563,457341,1033448,753370,296824,482429,562212,335117,676703,831590,16430,350820,1003557,830075,884548,733338,964883,306155,473216,940291,290059,503501,446320,132535,604779,650835,1037041,427269,94415,989658,873378,841867,147963,510297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]