SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587596 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587596 [ RunTime:0.003668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606251,465029,62073,942525,850937,496440,564814,688727,313020,299517,170572,926406,851420,863365,284987,605151,824223,330339,567182,892218,336167,682209,251248,555655,636278,661102,40967,316749,547126,514661,141884,195880,745066,318025,177565,591699,996929,444089,190931,964525,923589,642759,400866,641642,166012,292352,327105,154864,616541,684057,134584,837293,730869,490751,852861,377547,537271,461286,786926,462391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]