SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001511 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001511 [ RunTime:0.001498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612524,49375,408628,928398,259584,887356,629354,860804,458671,127894,248356,406365,459807,673269,898437,461185,872568,418495,216441,93766,963318,782346,1012701,980982,313319,700094,1038116,1036839,539538,318578,921029,513975,1042331,924768,303280,222429,724571,626568,331113,68547,47824,440554,247900,549036,1038785,982222,173126,615191,980147,784832,764523,909145,1043747,257882,806471,562540,158213,290146,339715,378058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]