SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 361978 LIMIT 1 [ RunTime:0.003022s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 361978 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891103,731536,53009,155823,885863,62593,591158,748326,823449,139151,661049,747275,599168,621746,203400,902560,540766,575861,961374,681904,61436,221408,779495,727774,157001,1029265,156605,832653,448701,391141,741625,344730,772885,25744,865082,498445,261670,791667,188467,934435,674546,182764,139115,712438,536877,719497,303273,977424,1035287,661263,659097,290705,256150,323622,193718,364164,505958,862908,293429,105952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 361978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 361978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]