SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420075 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420075 [ RunTime:0.002483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649935,877478,1047934,109142,1037539,829588,813820,433205,567420,795260,676765,327209,515243,778323,945655,156735,251580,712984,387075,115661,260394,261092,74559,583140,115278,236098,334849,835182,1022994,1017203,281741,538508,1017452,106030,369040,197113,998738,528834,153026,288202,701012,137450,452220,719155,157323,428435,957068,587163,37956,397275,267849,357223,828131,1028657,197422,497268,614798,143279,740832,132070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]