SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5481 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5481 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158365,433566,977358,667970,1017360,259493,274348,53752,58022,982457,320636,298761,317471,696263,569503,125144,99613,943338,138362,922636,930425,658564,22640,748436,398830,211703,779762,641768,677279,387771,39344,200768,541832,39658,708629,928914,995151,786121,226690,226442,919551,905337,149599,973177,587283,631996,975658,445115,785334,855334,829748,116621,578538,78926,371449,536361,1048086,49535,75011,925370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]