SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579071 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579071 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028395,150877,810234,122668,333959,954538,520386,493017,434594,246002,129821,538012,264788,823177,983834,497228,575402,147535,895168,401615,717072,462026,883018,818387,695593,410346,136015,830839,951766,382876,640816,897680,514852,427424,423733,431595,392174,550811,165487,171137,369105,297451,851791,646212,1004641,962095,986443,537290,646228,454783,145021,608095,431429,412723,965289,328505,703048,262596,68342,140272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]