SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426535 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426535 [ RunTime:0.003433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563662,324664,269449,322741,358010,423733,978573,142069,544930,351458,915349,130469,272053,28702,727643,692698,746570,12360,293623,214783,692091,629474,103886,127260,956103,429812,418716,158578,423893,776329,901077,626258,854338,940734,481314,67790,558213,393441,883187,59211,251358,681631,132094,412353,398511,997071,1039596,224440,486690,219681,304322,1024063,355297,147358,321640,850355,752581,896023,1046795,376059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]