SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030098 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030098 [ RunTime:0.002816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037227,776896,740328,292422,201899,845861,14361,221421,40128,742586,124050,448778,186852,128310,501651,982139,291904,465465,39421,748454,259092,582123,410920,397750,584476,970108,171270,35361,934790,638964,779335,337439,796224,529915,307373,132727,287677,683647,695262,414325,176016,1036515,498810,228157,902479,510868,837723,875003,990862,123354,433900,116782,254641,710538,152892,288197,430786,993513,183571,884220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]