SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504325 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504325 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252586,141179,1017316,243705,40094,141826,84483,148623,507764,78271,127425,644862,616963,1031164,49120,103289,381362,178119,710543,416564,760636,34648,325452,568149,68328,204483,509968,683043,167306,462083,736882,609587,238245,534934,185112,966257,814148,653114,748715,561433,383420,594396,565752,608803,78214,287354,966625,58923,716382,412913,1039762,478610,911124,288474,512523,132540,260519,872901,357805,297343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]